$fsr_id = $_REQUEST['m']; /* $path = '/home/users/web/b2037/ipw.panamacitybassmasters/public_html/cgi-bin'; set_include_path(get_include_path() . PATH_SEPARATOR . $path); */ ##include('cgi-bin/pcbmdbinfo.inc.php'); mysql_select_db('panamaci_pcbm') or die('Could not select database'); // Performing category SQL query $query = "SELECT category, catdesc FROM category ORDER by category"; $results = mysql_query($query) or die('Category Query failed: ' . mysql_error()); while ($row = mysql_fetch_assoc($results)) { $category_array[$row[category]] = $row[catdesc]; } // Free resultset mysql_free_result($results); // Performing manufacturer SQL query $query = 'SELECT m_id, type, shtname FROM manufacturer ORDER BY type, m_id'; $results = mysql_query($query) or die('Manufacturer Query failed: ' . mysql_error()); while ($row = mysql_fetch_assoc($results)) {# 5 if ($row[type] == 1) { $boat_array[$row[m_id]] = $row[shtname]; } else {# 4 if ($row[type] == 2) { $truck_array[$row[m_id]] = $row[shtname]; } else {# 3 if ($row[type] == 3) { $rod_array[$row[m_id]] = $row[shtname]; } else {# 2 if ($row[type] == 4) { $trolling_array[$row[m_id]] = $row[shtname]; } else {# 1 if ($row[type] == 5) { $outboard_array[$row[m_id]] = $row[shtname]; } else { } }# 1 }# 2 }# 3 }# 4 $manuf_array[$row[m_id]] = $row[shtname]; }# 5 // Free resultset mysql_free_result($results); // Performing for_sale SQL query $query = "SELECT status, email, item, manuf FROM for_sale WHERE $fsr_id = fsid"; $results = mysql_query($query) or die('For_Sale Query failed: ' . mysql_error()); $row = mysql_fetch_assoc($results); $item = $category_array[$row[item]]; $manuf = $manuf_array[$row[manuf]]; $email = $row[email]; $status = $row[status]; // status A=approved, I=inactive, P=pending, S=sold // emver V=verified if ($status != "P") { echo "Status not set to \"P\" pending for record id= ". $fsr_id; } else { $adddate = date('Y-m-d H:i:s'); $query = "UPDATE for_sale SET status='A', addate='$adddate' WHERE fsid = ". $fsr_id; mysql_query($query) or die('For_Sale Update Query failed: ' . mysql_error()); // Free resultset mysql_free_result($results); // Closing connection mysql_close($link); ?>
Status for email address
with a and record id
has been approved.
} ?>